﻿CREATE TABLE [dbo].[EventLog] (
    [ComputerId]      INT            NOT NULL,
    [LogFile]         NVARCHAR (100) NOT NULL,
    [RecordNumber]    INT            NOT NULL,
    [Category]        NVARCHAR (100) NULL,
    [EventIdentifier] INT            NULL,
    [EventTypeId]     TINYINT        NOT NULL,
    [Message]         NVARCHAR (MAX) NULL,
    [SourceName]      NVARCHAR (300) NULL,
    [TimeGenerated]   DATETIME       NULL,
    [TimeWritten]     DATETIME       NULL,
    [User]            NVARCHAR (50)  NULL
);

